<?php
date_default_timezone_set("PRC");

$dsn="mysql:Server=127.0.0.1;dbname=blog";
$db= new PDO($dsn, "root", "123456");
$db ->exec("set names utf8mb4");

$sql ="select * from category order by category_id desc";
$result =$db->query($sql);
$categoryList =$result->fetchAll(PDO::FETCH_ASSOC);
?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
    <link rel="stylesheet" href="css/mian.css" />
</head>
<body>
<div id="container">
    <div id="top">
        <h1>博客管理系统</h1>
<!--        <div id="top_id">欢迎您：admin，<a href="#">退出登录</a></div>-->
    </div>
    <div id="left">
        <ul>
            <li><a href="category_list.php">分类管理</a></li>
            <li><a href="article_list.php">新闻管理</a></li>
<!--            <li><a href="#">管理员</a></li>-->
        </ul>
    </div>
    <div id="right">
        <div id="right_tao">
            <a href="article_list.php">首页</a>
            <a href="article_list.php">文章管理</a>
            <a href="article_add.php">增加文章</a>
            <div id="ad_table_list">
                <form action="article_add_save.php" method="post">
                    <table border="" cellspacing="" cellpadding="">
                        <tr>
                            <td>文章标题:</td>
                            <td><input type="text" name="article_title"  /></td>
                        </tr>
                        <tr>
                            <td>所属分类：</td>
                            <td>
                                <select name="category_id">
                                    <?php foreach ($categoryList as $value): ?>
                                        <option value="<?php echo $value['category_id']?>">
                                            <?php echo $value['category_name'];?>
                                        </option>
                                    <?php endforeach;?>
                                </select>
                            </td>
                        </tr>
                        <tr>
                            <td>文章简介：</td>
                            <td>
                                <textarea name="intro"></textarea>
                            </td>
                        </tr>
                        <tr>
                            <td>文章内容:</td>
                            <td>
                                <textarea name="article_content" ></textarea>
                            </td>
                        </tr>
                        <tr>
                            <td></td>
                            <td><input type="submit" value="提交"  class="but" />
                                <input type="reset" value="重置"  class="but" /></td>
                        </tr>
                    </table>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
